inherited frmFixAssetChangeBill: TfrmFixAssetChangeBill
  Left = 328
  Top = 141
  Caption = #22266#23450#36164#20135#21464#21270#28165#21333
  ClientWidth = 882
  ExplicitWidth = 900
  PixelsPerInch = 119
  TextHeight = 12
  inherited Panel1: TPanel
    Width = 882
    inherited img3: TImage
      Left = 559
    end
    inherited edtFilter: TcxTextEdit
      ExplicitHeight = 20
    end
  end
  inherited pnlMain: TPanel
    Width = 882
    inherited MainDataGrid: TcxGrid
      Width = 882
      inherited MainDataGridDBTableView: TcxGridDBTableView
        object cxgrdbclmnCode: TcxGridDBColumn
          Caption = #25968#25454#32534#30721
          DataBinding.FieldName = 'code'
        end
        object cxgrdbclmnName: TcxGridDBColumn
          Caption = #22266#23450#36164#20135#21517#31216
          DataBinding.FieldName = 'name'
          Width = 111
        end
        object cxgrdbclmnOperationDate: TcxGridDBColumn
          Caption = #26085#26399
          DataBinding.FieldName = 'operationdate'
          Width = 140
        end
        object cxgrdbclmnVourchId: TcxGridDBColumn
          Caption = #30456#20851#20973#35777
          DataBinding.FieldName = 'voucherid'
          Width = 105
        end
        object cxgrdbclmnOperationType: TcxGridDBColumn
          Caption = #25968#25454#31867#22411
          DataBinding.FieldName = 'operationtype'
          Width = 148
        end
        object cxgrdbclmnDataValue: TcxGridDBColumn
          Caption = #25968#25454#35828#26126
          DataBinding.FieldName = 'datavalue'
          Width = 127
        end
        object cxgrdbclmnFilName: TcxGridDBColumn
          Caption = #20998#25903#26426#26500
          DataBinding.FieldName = 'filname'
          Width = 138
        end
      end
    end
  end
  inherited pnlBottom: TPanel
    Width = 882
    inherited chkGroupSort: TcxCheckBox
      Left = 555
      ExplicitLeft = 555
      ExplicitWidth = 69
      ExplicitHeight = 20
    end
    inherited chkHandGroup: TcxCheckBox
      Left = 631
      ExplicitLeft = 631
      ExplicitWidth = 69
      ExplicitHeight = 20
    end
    inherited edtPause: TcxComboBox
      Left = 829
      ExplicitLeft = 829
      ExplicitWidth = 46
      ExplicitHeight = 20
      Width = 46
    end
    inherited chkGridFilter: TcxCheckBox
      Left = 759
      ExplicitLeft = 759
      ExplicitWidth = 69
      ExplicitHeight = 20
    end
    inherited btnNew: TcxButton
      TabOrder = 7
    end
    inline dfFixAst: TFrameSetDateFilter
      Left = 196
      Top = 8
      Width = 355
      Height = 26
      TabOrder = 6
      ExplicitLeft = 196
      ExplicitTop = 8
      inherited edtDateFilter: TcxComboBox
        Properties.OnChange = nil
        ExplicitHeight = 20
      end
      inherited edtBDate: TcxDateEdit
        Properties.OnChange = nil
        ExplicitHeight = 20
      end
      inherited edtEDate: TcxDateEdit
        Properties.OnChange = nil
        ExplicitHeight = 20
      end
    end
  end
  inherited MainDataSetU: TUniQuery
    SQL.Strings = (
      
        'Select f.FixedAssetID As ID,f.Addvoucherid As voucherid,f.AssetC' +
        'ode As Code,f.Name,'
      
        '       f.UsedDate AS OperationDate,Cast('#39#26032#22686#22266#23450#36164#20135#39'As VarChar(20)) ' +
        'As OperationType,'
      
        '       Cast('#39#26032#22686#22266#23450#36164#20135#65306#39' + Cast(Round(f.STARTRAWAMT,2) As VarChar(1' +
        '6)) As VarChar(40)) As DataValue,'
      '       f.filid,s.fi_filnm AS filname'
      'From tfb_fixedassets f,td_filiale s'
      'Where  f.filid = s.fi_filid'
      '  And f.UsedDate>=:dtFirst1 And f.UsedDate<=:dtLast1'
      'Union'
      
        'Select f.FixedAssetID As ID,f.Delvoucherid As voucherid,f.AssetC' +
        'ode As Code,f.Name,'
      
        '       f.ClearDate AS OperationDate,Cast('#39#28165#29702#22266#23450#36164#20135#39' As VarChar(20)' +
        ') As OperationType,'
      
        '       Cast('#39#28165#29702#22266#23450#36164#20135#65306#39' + Cast(Round(f.RAWAmt,2) As VarChar(16)) A' +
        's VarChar(40)) As DataValue,'
      '       f.filid,s.fi_filnm as filname'
      'From tfb_fixedassets f,td_filiale s'
      'Where f.filid = s.fi_filid'
      '  And (fadeltypeid Is Not NULL)'
      '  And ClearDate>=:dtFirst2 And ClearDate<=:dtLast2'
      'Union'
      
        'Select m.FAAdjID As ID,voucherid As voucherid,m.Code As Code,f.N' +
        'ame,'
      
        '       m.ChangeDate AS OperationDate,Cast('#39#22266#23450#36164#20135#21464#21160#39' As VarChar(20' +
        ')) As OperationType,'
      
        '       Cast(('#39#21407#20540#35843#22686#65306#39' + Cast(Round(m.NewRawAmt-m.OldRawAmt,2) As ' +
        'VarChar(16))) As VarChar(40)) As DataValue,'
      '       f.filid,s.fi_filnm as filname'
      
        'From tfb_fixastmodify m,tfb_fixedassets f,tfd_fixastsmodtype t,t' +
        'd_filiale s'
      'Where f.FixedAssetID = m.FixedAssetID'
      '  And f.filid = s.fi_filid'
      '  And m.MODTYPEID = t.ID'
      '  And m.MODTYPEID = 1'
      '  And m.NewRawAmt>m.OldRawAmt'
      '  And m.ChangeDate>=:dtFirst3 And m.ChangeDate<=:dtLast3'
      'Union'
      
        'Select m.FAAdjID As ID,voucherid As voucherid,m.Code As Code,f.N' +
        'ame,'
      
        '       m.ChangeDate AS OperationDate,Cast('#39#22266#23450#36164#20135#21464#21160#39' As VarChar(20' +
        ')) As OperationType,'
      
        '       Cast(('#39#21407#20540#35843#20943#65306#39' + Cast(Round(m.OldRawAmt- m.NewRawAmt,2) As' +
        ' VarChar(16))) As VarChar(40)) As DataValue,'
      '       f.filid,s.fi_filnm as filname'
      
        'From tfb_fixastmodify m,tfb_fixedassets f,tfd_fixastsmodtype t,t' +
        'd_filiale s'
      'Where f.FixedAssetID = m.FixedAssetID'
      '  And f.filid = s.fi_filid'
      '  And m.MODTYPEID = t.id'
      '  And m.MODTYPEID = 1'
      '  And m.NewRawAmt<m.OldRawAmt'
      '  And m.ChangeDate>=:dtFirst4 And m.ChangeDate<=:dtLast4'
      'Union'
      
        'Select m.FAAdjID As ID,voucherid As voucherid,m.Code As Code,f.N' +
        'ame,'
      
        '       m.ChangeDate AS OperationDate,Cast('#39#22266#23450#36164#20135#21464#21160#39' As VarChar(20' +
        ')) As OperationType,'
      
        '       Cast(('#39#32047#35745#25240#26087#35843#22686#65306#39' + Cast(Round(m.NewSumDeprAmt - m.OldSumDe' +
        'prAmt,2) As VarChar(16))) As VarChar(40)) As DataValue,'
      '       f.filid,s.fi_filnm as filname'
      
        'From tfb_fixastmodify m,tfb_fixedassets f,tfd_fixastsmodtype t,t' +
        'd_filiale s'
      'Where f.FixedAssetID = m.FixedAssetID'
      '  And f.filid = s.fi_filid'
      '  And m.MODTYPEID = t.id'
      '  And m.ModTypeID = 6'
      '  And m.NewSumDeprAmt > m.OldSumDeprAmt'
      '  And m.ChangeDate>=:dtFirst5 And m.ChangeDate<=:dtLast5'
      'Union'
      
        'Select m.FAAdjID As ID,voucherid As voucherid,m.Code As Code,f.N' +
        'ame,'
      
        '       m.ChangeDate AS OperationDate,Cast('#39#22266#23450#36164#20135#21464#21160#39' As VarChar(20' +
        ')) As OperationType,'
      
        '       Cast(('#39#32047#35745#25240#26087#35843#20943#65306#39' + Cast(Round(m.OldSumDeprAmt - m.NewSumDe' +
        'prAmt,2) As VarChar(16))) As VarChar(40)) As DataValue,'
      '       f.filid,s.fi_filnm as filname'
      
        'From tfb_fixastmodify m,tfb_fixedassets f,tfd_fixastsmodtype t,t' +
        'd_filiale s'
      'Where f.FixedAssetID = m.FixedAssetID'
      '  And f.filid = s.fi_filid'
      '  And m.MODTYPEID = t.id'
      '  And m.ModTypeID = 6'
      '  And m.NewSumDeprAmt < m.OldSumDeprAmt'
      '  And m.ChangeDate>=:dtFirst6 And m.ChangeDate<=:dtLast6'
      'Union'
      
        'Select m.FAAdjID As ID,voucherid As voucherid,m.Code As Code,f.N' +
        'ame,'
      
        '       m.ChangeDate AS OperationDate,Cast('#39#22266#23450#36164#20135#21464#21160#39' As VarChar(20' +
        ')) As OperationType,'
      '       Cast('#39#22266#23450#36164#20135#31185#30446#21464#21160'......'#39' As VarChar(40)) As DataValue,'
      '       f.filid,s.fi_filnm as filname'
      
        'From tfb_fixastmodify m,tfb_fixedassets f,tfd_fixastsmodtype t,t' +
        'd_filiale s'
      'Where f.FixedAssetID = m.FixedAssetID'
      '  And f.filid = s.fi_filid'
      '  And m.MODTYPEID = t.id'
      '  And m.ModTypeID = 9'
      '  And m.ChangeDate>=:dtFirst7 And m.ChangeDate<=:dtLast7'
      'Union'
      
        'Select m.FAAdjID As ID,voucherid As voucherid,m.Code As Code,f.N' +
        'ame,'
      
        '       m.ChangeDate AS OperationDate,Cast('#39#22266#23450#36164#20135#21464#21160#39' As VarChar(20' +
        ')) As OperationType,'
      '       Cast(t.name + '#39'......'#39' As VarChar(40)) As DataValue,'
      '       f.filid,s.fi_filnm as filname'
      
        'From tfb_fixastmodify m,tfb_fixedassets f,tfd_fixastsmodtype t,t' +
        'd_filiale s'
      'Where f.FixedAssetID = m.FixedAssetID'
      '  And f.filid = s.fi_filid'
      '  And m.MODTYPEID = t.id'
      '  And m.ModTypeID <> 1'
      '  And m.ModTypeID <> 6'
      '  And m.ModTypeID <> 9'
      '  And m.ChangeDate>=:dtFirst8 And m.ChangeDate<=:dtLast8')
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'dtFirst1'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtLast1'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtFirst2'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtLast2'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtFirst3'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtLast3'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtFirst4'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtLast4'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtFirst5'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtLast5'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtFirst6'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtLast6'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtFirst7'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtLast7'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtFirst8'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'dtLast8'
        Value = nil
      end>
  end
end
